﻿
CREATE proc [dbo].[proc_Project_GetExecPerson]
(
	@projectid nvarchar(100)
)
as
	Select ExecPersonName,ExecDepartmentId From Project_Task
	Where ProjectId = @projectid and ExecDepartmentId <> ''  and ExecPerson <> ''